Worksheets can obtain data from the drawing based on specified criteria, and then list the data and allow calculations to be performed on the data. Use a spreadsheet row to add text, formula, or numbers to the worksheet. Use a database row to specify the criteria for obtaining drawing data, and to specify the contents of each column. See Specifying the Worksheet Row Type to select the type of worksheet row. For information on entering data in spreadsheet cells and database rows, see Entering Data.
The cells in a spreadsheet row contain text, formulas, or numbers. Text helps to identify the purpose of a worksheet and labels the columns in a worksheet. Numbers represent drawing data or the results of a formula. Insert formulas to perform calculations based on drawing data; Vectorworks includes more than 30 built-in operation functions (see Additional Worksheet Operations).
Database rows display information about objects in a drawing. The database header row is identified by the diamond shape next to the row number. In this row, set the criteria to determine which objects will be listed in the related sub-rows. For example, you might set a header row to list all symbols in the drawing. A sub-row would then be generated for each symbol in the drawing. (If no object meets the header row criteria, no sub-rows are created.)
Many criteria combinations can be specified, including an object’s name, record information, line weight, fill pattern, layer, or class. For example, create a list of all the rooms in a resort, or list only the green wing-backed chairs from all the two-room suites that are scattered throughout the resort.
For each column in the database header row, specify what information about the objects to display. For example, if a database row lists all of the rooms in a building, you might define column A to be the room name, column B to be the room number, and column C to be the floor number.
To select all database objects that meet the database row criteria, right-click (Windows) or Ctrl-click (Macintosh) on the database header row to open the context menu.
To select an individual database object, right-click (Windows) or Ctrl-click (Macintosh) on the specific database object to open the context menu.
|
2.
|
All database objects that are represented by the header row, or the individual row object, are selected. If an individual object was selected with Select Item, the drawing view changes to display the selected object.
|
2.
|
Select Database.
|
To specify additional criteria, click More Choices. The number of objects that meet the criteria displays. Click OK. Database functionality is now enabled for the row; beneath the header row, sub-rows are created for each drawing object that meets the criteria specified.
|
2.
|
Select Spreadsheet.
|
